SESSION
1
Total Time: 110
Minutes
Section A: Introduction
- SQL Server Goal
- SQL Platforms
- SQL Server
Section B: Installation Options
- System Requirements
- Architecture Enhancement
- Server Editions
- Multiple Instances
- Installation Options
- File Locations
- Collation
- Sort Order
- Domain Login
- Network Protocol
- Unattended Setup
Section C: Installation
- Basic Install
- Post Installation
- Register Server
- Check/Verify Logins
- Network Libraries
- Startup Option
- Start/Stop Services
- Verify Directories
Section D: Troubleshooting
Installations
- Basic Steps
- Common Install Failures
- SQL Agent Issues
- Client Issues
- Named Pipes
- TCP/IP
Section E: Upgrade from 6.5
- Requirements
- One/Two Computer Upgrade
- Consolidation
- Data Transfer Method
- Upgrade Checklist
- Upgrade Wizard
Section F: Upgrade Methods
- Overview
- Hardware/Software
Requirements
- Installation Upgrade
- Post Upgrade
- Warning
- Online Database Upgrade
- Online Upgrade Exceptions
- Upgrade & Replication
- Online Database Upgrade
- Installation Upgrade
Section G: Server Security
- Basic Steps
- Logon Methods
- Authentication Mode
- SQL Login Commands
- Group Usage
- Add NT User
- Connect Using NT
- Add SQL User
- Add NT Group
- Validate Login
- Deny Access
SESSION
2
Total
Time: 110 Minutes
Section A: Database Security
- Adding Users
- New User & Login
- Special Users
- Disable Guest
- Database User Command
Section B: Database Permissions
- Overview
- Object Permission
- Permission Rules
- Object References
- Chain of Ownership
- Chain Issues
- Dbo Ownership
- Roles
- Server Fixed Roles
- Database Fixed Roles
- Create a Role
- Permissions Accumulate
- Application Role
- Use of Application Roles
- Creating a Role
Section C: Creating Databases
- Databases in SQL Server
- Master/Model
- Temp db/MSdb/Distribution
- Database Objects
- File Types/Pages
- Transaction Log
- Create Database Options
- Syntax
- Recovery Considerations
- Create a Database
Section D: Placing Database
Files
- Storage Management
- RAID Options
- RAID 1
- RAID 0 on RAID 1
- RAID 5
- Filegroups
- Files in Filegroup
- Create Filegroups
- Using Filegroups
- Filegroups & Maintenance
- Performance Considerations
Section E: Altering a Database
- Using Alter Database
- Changing Database Options
- Setting Options
- Shrink Databases
- Examining Databases
- Space Estimation
- Rules of Thumb for Logs
SESSION
3
Total
Time: 105 Minutes
Section A: Constraints
- Default Constraint
- Create Default Constraint
- Check Constraint
- Check Constraint Abilities
- Using Check Constraints
- Add Records Using Check
Constraints
- Table Level Constraints
- Primary Key Constraints
- Create Primary Key
Constraints
- Multiple Column Primary Key
- Unique Constraints
Section B: Foreign Key
Constraints
- Planning Foreign Keys
- Foreign Keys & Table
Actions
- Rules for Foreign Keys
- Create Foreign Keys
- Using Foreign Keys
- Create Table Level
Constraint
- Altering Tables
- Disabling Constraints
Section C: Indexes
- Overview
- Indexes & Data
Storage/Access
- Clustered Index
- Planning Clustered Index
- Non-Clustered Index
- Non-Clustered with Clustered
Section D: Index Maintenance
- Creating Indexes
- Empty Pages
- Full Pages
- Fill Factor
- Drop an Index
- Tips for Using Indexes
- Using Indexes
Section E: Stored Procedures
- Overview
- Planning Stored Procedures
- Create/Execute
- Using Stored Procedures
SESSION
4
Total
Time: 103 Minutes
Section A: Triggers
- Overview
- Planning Use of Triggers
- After Trigger
- Inserted/Deleted Table
- Create Triggers
- Using Triggers
- After vs. Instead of
Section B: Views
- Overview
- Planning Use of Views
- Details of Views
- Customize View
- Insert in Views
- Indexed View
- Set Stats/Execution Plan
- Partitioned Views
Section C: Database Backup
- Why Backups?
- Backup Models
- Full Recovery
- Bulk-Logged Recovery
- Simple Recovery
- Permissions Required
- Backup Methods
- Backup Timing
- Full Backup
- Using Dump Device
- Backup Options
- Tape Option
- Create Backup
- Enterprise Manager
- Differential Backup
Section D: Backup Transaction
Logs
- Why Backup Logs?
- Normal Log Backup
- Truncate Only/No Log
- Log Full
- Long Transactions
- View from Enterprise Manager
- Backup No Truncate
- Standard Scenario
Section E: Filegroup/Optimize
Backups
- Overview
- Filegrouping
- Large Database Backup
- Filegroup Scenario
- Optimizing Backups
- Stripped Backup
- Backup Performance
SESSION
5
Total
Time: 116 Minutes
Section A: Restore &
Recovery
- Automatic Recovery
- Transaction Log with
Recovery
- Restore Process
- Check Media
- Restore Steps
- Restore Options
- Restoring Log
- Restoring Master
- Restore Scenario
- Restore Database
- Restore Logs
- Basic Restore Commands
Section B: High Availability
Solutions
- Overview
- Standby Server
- Log Shipping
- Starting SQL Agent
- Setup Log Shipping
- Setup Backup Criteria
- Troubleshooting Log Shipping
- Log Ship Role Change
- User/Login Mapping
- Cluster Server
- Windows Clustering
- SQL Clustering
- Active/Passive Cluster
- Active/Active Cluster
- Log vs. Cluster
Section C: Relocating Data
- Overview
- Attach/Detach Database
- DTS
- Create DTS Package
- DTS Tasks/Steps
- Transform Data
- Data Lineage
- Use DTA Wizard
- DTS Designer
- Verify Metadata
- DTS Workflow
- Change Data Type
- Export/Import DTS
- Import File
- Bulk Insert/BCP
Section D: Replication Overview
- Why Replication
- Replication vs. DTS
- Roles & Language
- Publications/Articles
- Publisher/Subscriber
- Remote Distribution
SESSION
6
Total
Time: 100 Minutes
Section A: Types of Replication
- Overview
- Snapshot
- Transactional
- Merge
- Updating Subscribers
- New Replication Features
Section B: Implementing
Replication
- Planning
- Designing
- Distributor Setup
- Configuring a Distributor
- Publisher Setup
- Configuring a Publisher
- Create Publication
- Push Subscription
- Replication Monitor
- Alerts
- Updating Subscribers
- Troubleshooting Replication
- Internet/Heterogeneous
Replication
Section C: Linked Servers
- Distributed Query
- Setting Up a Linked Server
- Linked Server Options
- Troubleshooting Linked
Servers
- Changing Data
- Create Linked Server
- Link to Excel Spreadsheet
Section D: Server Automation
- Overview
- Setup Mail Integration
- Test Mail Integration
- Create Operator
- Create Jobs
- Advanced Options/Create
Steps
- Notifications
- Using Jobs
SESSION
7
Total
Time: 112 Minutes
Section A: Managing Automation
- Alerts
- Using Raise Error
- Error Log/NT Event Log
- XP-Log Events
- Create Alerts
- Respond to Alerts
- Multiple Operator
Notification
- Performance Monitor Alert
- Failsafe Operator/Master
Server Wizard
- Alert Response Delay
- Automation Troubleshooting
Section B: SQL Mail Integration
- SQL Mail Setup
- Using SQL Mail
- Triggers
- Mail Troubleshooting
Section C: Monitoring SQL
Server
- Overview
- Memory Monitoring
- Processor Monitoring
- Disk I/O Monitoring
- System Monitor
- SQL Server Monitoring
- Optimize Processor Use
- Monitoring Locks
- SP_WHO Command
- Locks in Enterprise Manager
- Deadlock (1205) Error
- Profiler
- Using Profiler
- Server Configuration
- DBCC
Section D: Optimizing Database
Performance
- External Fragmentation
- Data Fragmentation
- Index Statistics
- Using Indexes
- Query Statistics
- Execution Plans
- Optimize Queries
- Re-Compiling Stored
Procedures
Section E: IIS Virtual
Directory
- Creating the Virtual
Directory
- Configure XML Support
- Using Internet Explorer with
SQL
- Section F: Security Auditing
- Methods
- C2 Auditing
- C2 vs. SQL Profiler
- Additional Resources
|